use vudu
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[ConsultarEscuelaP]
@correo VARCHAR(50)
AS
BEGIN
	SET NOCOUNT ON;

SELECT e.* FROM Escuela e, Rol r 
WHERE e.fk_rol = r.id_rol 
AND r.correo = @correo

END;
